NetSuite

Adding NetSuite as data source

Prequisites for adding NetSuite

The following connector information is required from the client:

• Realm ID

• Consumer Key

• Consumer Secret

• Token Key

• Token Secret

• Start Date

• Window in Days (Default: 30 days)

Do the following:

1. Create NetSuite account

a. Create account on Oracle NetSuite.

b. Create account on Oracle NetSuite.

c. Confirm your Email.

d. Confirm your Email.

2. Setup NetSuite account

a. Obtain Realm info

1. Login into your NetSuite account

2. Go to Setup » Company » Company Information.

3. Copy your Account ID (Realm). It should look like 1234567 for the Production env. or 1234567_SB2 for a Sandbox.

b. Enable features

1. Go to Setup » Company » Enable Features.

2. Click on SuiteCloud tab.

3. Scroll down to SuiteScript section.

4. Enable checkbox for CLIENT SUITESCRIPT and SERVER SUITESCRIPT.

5. Scroll down to Manage Authentication section.

6. Enable checkbox TOKEN-BASED AUTHENTICATION.

7. Scroll down to SuiteTalk (Web Services).

8. Enable checkbox REST WEB SERVISES.

9. Save the changes.

c. Create Integration (obtain Consumer Key and Consumer Secret)

1. Go to Setup » Integration » Manage Integrations » New.

2. Fill the Name field (we recommend to put airbyte-rest-integration for a name).

3. Make sure the State is enabled.

4. Enable checkbox Token-Based Authentication in Authentication section.

5. Save changes.

6. After that, Consumer Key and Consumer Secret will be showed once (copy them to the safe place).

d. Setup Role

1. Go to Setup » Users/Roles » Manage Roles » New.

2. Fill the Name field (we recommend to put airbyte-integration-role for a name).

3. Scroll down to Permissions tab.

4. (REQUIRED) Click on Transactions and manually add all the dropdown entities with either full or view access level.

5. (REQUIRED) Click Reports and manually add all the dropdown entities with either full or view access level.

6. (REQUIRED) Click Lists and manually add all the dropdown entities with either full or view access level.

7. (REQUIRED) Click on Setup and manually add all the dropdown entities with either full or view access level.

Note

• Make sure you have done all the REQUIRED steps correctly, to avoid sync issues in the future.

• Edit these parameters again when you rename or customise any Object in NetSuite for airbyte-integration-role to reflect such changes.

e. Setup User

1. Go to Setup » Users/Roles » Manage Users.

2. In column Name click on the user’s name you want to give access to the airbyte-integration-role.

3. Then click on Edit button under the user’s name.

4. Scroll down to Access tab at the bottom.

5. Select from drop-down list the airbyte-integration-role role which you created in step 2.4.

6. Save changes.

f. Create Access Token for role

1. Go to Setup » Users/Roles » Access Tokens » New.

2. Select an Application Name.

3. Under User select the user you assigned the airbyte-integration-role in the step 2.4.

4. Inside Role select the one you gave to the user in the step 2.5.

5. Under Token Name you can give a descriptive name to the Token you are creating (we recommend to put airbyte-rest-integration-token for a name).

6. Save changes. After that, Token ID and Token Secret will be showed once (copy them to the safe place).

To add NetSuite as a data source, do the following:

1. From the left navigation panel, click Lakehouse and then click Data Sources.

2. From the upper right corner of the page, click the + New Database button to start the process of adding a new database.

3. In the New Data Source page, click the NetSuite icon.

4. Specify the following details to add NetSuite. Once you have connected a data source, the system immediately fetches its schema. After this schema retrieval process is complete you can browse and interact with the tables and data.

   

   Field	Description
   Connection Name	Enter a unique name for this connection. This will help you identify it later.
   Realm (Account ID)	Netsuite realm e.g. 2344535 for production or 2344535_SB1, as for the sandbox
   Consumer Key	Consumer key associated with your integration
   Consumer Secret	Consumer secret associated with your integration
   Token Key (Token ID)	Access token key
   Token Secret*	Access token secret
   Start Date*	Enter the date in the MM-DD-YYYY format. DataGOL will replicate the data updated on and after this date.
   Window in Days	The amount of days used to query the data with date chunks. Set smaller value, if you have lots of data.

5. Click Submit.

Sync modes

The NetSuite source connector supports the following sync modes:

• Full Refresh
• Incremental